package guoanmaker.provider.business.repository;

import java.util.List;
import java.util.Optional;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import guoanmaker.provider.business.model.ProvideArea;
import guoanmaker.provider.business.model.ProvideCity;

public interface ProvideAreaRepository extends JpaRepository<ProvideArea, String>, JpaSpecificationExecutor<ProvideArea> {
	  @Query("select u from ProvideArea u where u.citycode=:citycode")
	    public List<ProvideArea> findBycode(@Param("citycode") String citycode);
}
